首页

prisma sqlite并发错误

最近我在解决我的系统并发问题时(Effect实现接口并发控制)遇到了这个问题
log
API调用失败: Error calling enhanced Prisma method `word.update`: Socket timeout (the database failed to respond to a query within the configured timeout). at (/home/admin/node_modules/.pnpm/@zenstackhq+runtime@2.15.1_@prisma+client@6.7.0_prisma@6.7.0_typescript@5.8.3__typescript@5.8.3_/node_modules/@zenstackhq/src/enhancements/edge/proxy.ts:322:33), at executeCall (/home/admin/app/TsFullStack/src/rpc/index.ts:131:26), at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
解决方案很简单,添加连接数限制就可以了 connection_limit=1​,示例:
DATABASE_URL="file:/home/admin/app/TsFullStack/prisma/dev.db?connection_limit=1&socket_timeout=10"